    <?php
    //for ($i=1; $i<=5; $i++)
    //{
    //    echo "The number is " . $i=>1 . "<br>";
    //}
    //phpinfo();


    //namespace app\api\model;

    //define('CLIENT_MULTI_RESULTS',131072);

    /*
    $host="119.23.241.96";
    $user="root";
    $password="ddykZC8MeDiwSfYJ";
    $id=$_REQUEST["id"];
    $cxn = mysql_connect($host,$user,$password,1,CLIENT_MULTI_RESULTS) or die("Could not connect: ".mysql_error());

    $db=mysql_select_db("agencymanager");

    $res=mysql_query("call outstatement(@str)",$cxn); 
    $res=mysql_query("select @str",$cxn); 
    $row=mysql_fetch_row($res);
    echo $row[0];

    */
    //------------------------------------------------
    // [ 应用入口文件 ]
    // 定义应用目录
    define('APP_PATH', __DIR__ . '/../application/');

    // 判断是否安装
    if (!is_file(APP_PATH . 'admin/command/Install/install.lock')) {
        header("location:./install.php");
        exit;
    }

    // 加载框架引导文件
    require __DIR__ . '/../thinkphp/start.php';



    //设置过滤方法
    $params["agentID"] = "admin";
    $params["userCount"] = "5";
   // $params["IP"] = "127.0.0.1";
    

    $must_param = [
        "agentID",
        "userCount",
    ];

    

    $in_out_column = [
        
    ];

    $out_column = [
        "userCount",
    ];
    //查询
    $procedure_name = 'backstagerobot_get_check_list';
    
    //查询
    //$procedure_name = 'backstagerobot_login';

    $model = new \app\api\model\DbCommon();

    echo("<br>");
    echo("<br>");
    echo("<br>");
    echo("<br>");

    //var_dump($model);
    //$model = model('application\api\model\DbCommon');
    $list = $model->mysql_procedure_execute($procedure_name,$must_param,$params,$out_column);

    echo("<br>");
    var_dump($list);
    echo("<br>");


    //设置过滤方法
    $params["robotUser"] = "licheng";
   // $params["userCount"] = "20";
   // $params["IP"] = "127.0.0.1";

    $must_param = [
        "robotUser",
    ];
    
    $out_column = [
        "fansInterval",
        "fansMaxTask",
        "videoInterval",
        "videoMaxTask",
        "videoMaxLikes",
        "videoMaxSpeak",
        "checkInterval",
        "checkMaxTask",
    ];
    //查询
    $procedure_name = 'agentrobot_param_get';
    
    $list = $model->mysql_procedure_execute($procedure_name,$must_param,$params,$out_column);
    //$this->success('返回成功', $list);
    echo("<br>");
    var_dump($list);
    echo("<br>");

    $params["agentrobotUser"] = "spider01";
    $params["userCount"] = 10;
    $params["lastdateNum"] = 1;


    $must_param = [
        "agentrobotUser",
        "lastdateNum",
       
    ];

    $in_out_column = [
        "userCount"
    ];

    $out_column = [
    ];

    //查询
    $procedure_name = 'agentrobot_get_sayhello_list';
    $list = $model->mysql_procedure_execute($procedure_name,$must_param,$params,$out_column,$in_out_column);
    
    echo("<br>");
    var_dump($list);
    echo("<br>");
    /*
    if($list && is_array($list) && count($list) == 1){
        $list = $list[0];
    }*/
    //$this->success('返回成功', $list);



        
    ?>